{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from pathlib import Path\n",
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "base_dir = Path(r'D:\\文档\\商品企划部\\临时需求\\40个牛仔\\grand_information1')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "a21_0704.csv\n",
      "Abercrombie&Fitch_0704.csv\n",
      "basichouse_0704.csv\n",
      "bershka_0704.csv\n",
      "cachecachebmnw_0704.csv\n",
      "ca_0704.csv\n",
      "dazzle_0704.csv\n",
      "dieselfs_0704.csv\n",
      "GXG_0704.csv\n",
      "Hollisterco_0704.csv\n",
      "JackJones_0704.csv\n",
      "jasonwood_0704.csv\n",
      "jucyjudy_0704.csv\n",
      "lee_0704.csv\n",
      "levis_0704.csv\n",
      "misssixty_0704.csv\n",
      "moco_0704.csv\n",
      "moussy_0704.csv\n",
      "only_0704.csv\n",
      "pullandbear_0704.csv\n",
      "stradivarius_0704.csv\n",
      "urfs_0704.csv\n",
      "veromoda_0704.csv\n",
      "ZARA_0704.csv\n",
      "乐町_0704.csv\n",
      "伊芙丽_0704.csv\n",
      "优衣库_0704.csv\n",
      "太平鸟官方_0704.csv\n",
      "太平鸟男装_0704.csv\n",
      "拉夏贝尔_0704.csv\n",
      "海澜之家_0704.csv\n",
      "马克华菲_0704.csv\n"
     ]
    }
   ],
   "source": [
    "df_files = []\n",
    "for one_pic in base_dir.iterdir():\n",
    "    print(one_pic.name)\n",
    "    df = pd.read_csv(open(one_pic, 'r', encoding='utf-8'), header=None)\n",
    "    df_files.append(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "total_df = pd.concat(df_files, sort=True, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>11</th>\n",
       "      <th>12</th>\n",
       "      <th>13</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>585000307760</td>\n",
       "      <td>A21夏季2019新款男装短袖T恤男纯色休闲基础百搭男士打底短袖上衣</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>17180.0</td>\n",
       "      <td>0</td>\n",
       "      <td>83048</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=585000307760</td>\n",
       "      <td>59.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>556905499087</td>\n",
       "      <td>A21男装男士外套冬季新款轻薄羽绒服男轻便薄款外套男短款</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0</td>\n",
       "      <td>46689</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=556905499087</td>\n",
       "      <td>219.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>579126304648</td>\n",
       "      <td>A21男装春夏季纯棉男裤牛仔裤男薄款小脚潮流 男生小直筒男款裤子</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/1601145275/O1...</td>\n",
       "      <td>7991.0</td>\n",
       "      <td>0</td>\n",
       "      <td>60043</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=579126304648</td>\n",
       "      <td>119.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>584857894258</td>\n",
       "      <td>A21夏季2019新款男装短袖T恤男潮牌纯色圆领打底衫男上衣假两件套</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>8541.0</td>\n",
       "      <td>0</td>\n",
       "      <td>49793</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=584857894258</td>\n",
       "      <td>69.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>574998833929</td>\n",
       "      <td>A21男装秋季纯色毛衣男宽松圆领针织衫男长袖套头衫男生青年线衣</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>11175</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=574998833929</td>\n",
       "      <td>169.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>585884370566</td>\n",
       "      <td>A21夏季2019新款男士短袖T恤潮流 简约百搭漫画体恤男ins潮港风</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/1601145275/O1...</td>\n",
       "      <td>7005.0</td>\n",
       "      <td>0</td>\n",
       "      <td>24834</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=585884370566</td>\n",
       "      <td>69.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>581181459462</td>\n",
       "      <td>A21新款男装纯棉休闲裤男纯色 小直筒卡其色男裤子青年时尚百搭</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>5918.0</td>\n",
       "      <td>0</td>\n",
       "      <td>50544</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=581181459462</td>\n",
       "      <td>119.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>573079737250</td>\n",
       "      <td>A21春季男装新款连帽卫衣男潮假两件套头潮流嘻哈男生外套</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0</td>\n",
       "      <td>20936</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=573079737250</td>\n",
       "      <td>149.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>584519564405</td>\n",
       "      <td>A21男装夏季2019黑白短袖条纹t恤男圆领半袖t恤男条纹衣服男潮流</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>4403.0</td>\n",
       "      <td>0</td>\n",
       "      <td>18716</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=584519564405</td>\n",
       "      <td>79.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>572188104468</td>\n",
       "      <td>A21春夏季工装裤男潮牌束脚 欧美嘻哈薄款九分休闲裤子男运动纯棉</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>192.0</td>\n",
       "      <td>0</td>\n",
       "      <td>29653</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=572188104468</td>\n",
       "      <td>159.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>555337765523</td>\n",
       "      <td>A21男修身牛仔裤潮流夏季弹力男士小脚裤休闲裤子男小脚长裤</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>2336.0</td>\n",
       "      <td>0</td>\n",
       "      <td>110354</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=555337765523</td>\n",
       "      <td>139.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>554745780852</td>\n",
       "      <td>A21男装春季新款长袖T恤男纯色男士圆领打底衫学生欧美修身上衣</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>110.0</td>\n",
       "      <td>0</td>\n",
       "      <td>42113</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=554745780852</td>\n",
       "      <td>69.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>586339532894</td>\n",
       "      <td>A21夏季男装新款黑色工装裤 潮流个性男士休闲裤束脚九分裤子男潮</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>3996.0</td>\n",
       "      <td>0</td>\n",
       "      <td>14274</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=586339532894</td>\n",
       "      <td>159.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>586840227706</td>\n",
       "      <td>A21夏季2019动漫印花T恤男生短袖男ins潮百搭 男士打底衫休闲时尚</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>5534.0</td>\n",
       "      <td>0</td>\n",
       "      <td>20959</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=586840227706</td>\n",
       "      <td>69.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>554820553199</td>\n",
       "      <td>A21男士衬衣秋季白衬衫男长袖纯棉休闲牛津纺修身白色上衣潮</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/1601145275/O1...</td>\n",
       "      <td>381.0</td>\n",
       "      <td>0</td>\n",
       "      <td>53897</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=554820553199</td>\n",
       "      <td>139.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>584858334178</td>\n",
       "      <td>A21夏季新款字母印花体恤男白色圆领5分袖男t恤宽松t恤男嘻哈短袖</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>1609.0</td>\n",
       "      <td>0</td>\n",
       "      <td>11750</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=584858334178</td>\n",
       "      <td>79.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>572319301147</td>\n",
       "      <td>A21新款春季男生牛仔裤男修身小脚潮流弹力春秋款男士裤子潮牌</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/1601145275/O1...</td>\n",
       "      <td>137.0</td>\n",
       "      <td>0</td>\n",
       "      <td>26742</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=572319301147</td>\n",
       "      <td>169.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>574480863419</td>\n",
       "      <td>A21春季英伦连帽风衣男短款时尚外套男撞色潮牌冲锋衣帅气</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>73.0</td>\n",
       "      <td>0</td>\n",
       "      <td>11931</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=574480863419</td>\n",
       "      <td>219.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>585000307753</td>\n",
       "      <td>A21新款2019夏季个性粉色T恤男短袖ins打底衫男圆领潮内搭男舒适</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>3332.0</td>\n",
       "      <td>0</td>\n",
       "      <td>16395</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=585000307753</td>\n",
       "      <td>79.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>586317028452</td>\n",
       "      <td>a21夏季新款男士动漫印花短袖t恤衫 纯棉衣服男潮牌个性休闲男装</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/1601145275/O1...</td>\n",
       "      <td>2297.0</td>\n",
       "      <td>0</td>\n",
       "      <td>12598</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=586317028452</td>\n",
       "      <td>69.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>572711994246</td>\n",
       "      <td>A21九分裤男修身秋季低腰弹力水洗学生简约男士牛仔裤潮</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>255.0</td>\n",
       "      <td>0</td>\n",
       "      <td>12760</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=572711994246</td>\n",
       "      <td>159.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>586840191726</td>\n",
       "      <td>A21夏季潮流新款束脚运动裤 印花弹力男装休闲裤黑色男士九分裤子</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/1601145275/O1...</td>\n",
       "      <td>3184.0</td>\n",
       "      <td>0</td>\n",
       "      <td>11385</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=586840191726</td>\n",
       "      <td>159.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>575214883533</td>\n",
       "      <td>A21春装外套男装黄色连帽卫衣男长袖学生潮牌时尚上衣</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0</td>\n",
       "      <td>6604</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=575214883533</td>\n",
       "      <td>149.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>584726585869</td>\n",
       "      <td>A21夏季2019休闲插肩袖T恤男撞色圆领短袖男ins潮百搭上衣男印花</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>1447.0</td>\n",
       "      <td>0</td>\n",
       "      <td>10657</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=584726585869</td>\n",
       "      <td>69.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>2</td>\n",
       "      <td>586556385876</td>\n",
       "      <td>A21夏季纯棉工装裤男潮牌宽松直筒工装裤男束脚拉绳休闲裤男九分</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>3278.0</td>\n",
       "      <td>0</td>\n",
       "      <td>12055</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=586556385876</td>\n",
       "      <td>169.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>2</td>\n",
       "      <td>586339028488</td>\n",
       "      <td>A21夏季新款纯色休闲裤男士 修身男装九分裤子潮流百搭学生小脚裤</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>1110.0</td>\n",
       "      <td>0</td>\n",
       "      <td>6247</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=586339028488</td>\n",
       "      <td>149.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>2</td>\n",
       "      <td>586888033034</td>\n",
       "      <td>A21男装原宿直筒休闲裤男九分束脚运动裤男小脚收口夏季薄款潮流</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>231.0</td>\n",
       "      <td>0</td>\n",
       "      <td>4232</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=586888033034</td>\n",
       "      <td>149.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>2</td>\n",
       "      <td>554908919545</td>\n",
       "      <td>A21夏季男士弹力休闲裤男修身潮流休闲百搭裤子男潮春夏小脚男裤</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>693.0</td>\n",
       "      <td>0</td>\n",
       "      <td>73035</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=554908919545</td>\n",
       "      <td>149.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>2</td>\n",
       "      <td>586840619069</td>\n",
       "      <td>A21夏季潮流新款短裤男潮牌 学生军绿男士裤子街头男装运动休闲裤</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/1601145275/O1...</td>\n",
       "      <td>4278.0</td>\n",
       "      <td>0</td>\n",
       "      <td>13359</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=586840619069</td>\n",
       "      <td>109.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>a21</td>\n",
       "      <td>a21fs</td>\n",
       "      <td>https://a21fs.m.tmall.com</td>\n",
       "      <td>32</td>\n",
       "      <td>2</td>\n",
       "      <td>572809503192</td>\n",
       "      <td>A21九分裤男束脚 学生弹力潮流青年黑色简约舒适运动裤男士休闲裤</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/1601145275/O1...</td>\n",
       "      <td>258.0</td>\n",
       "      <td>0</td>\n",
       "      <td>7613</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=572809503192</td>\n",
       "      <td>149.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70535</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>36</td>\n",
       "      <td>574608134171</td>\n",
       "      <td>马克华菲大衣男2018秋冬宽松潮流绣花翻领羊毛呢外套</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/94399436/TB2r...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>227</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=574608134171</td>\n",
       "      <td>898.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70536</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>36</td>\n",
       "      <td>564117145260</td>\n",
       "      <td>马克华菲男装春装新款时尚ins复古破洞九分牛仔裤工装裤男潮牌</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/94399436/TB1Z...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>332</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=564117145260</td>\n",
       "      <td>318.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70537</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>36</td>\n",
       "      <td>562348459515</td>\n",
       "      <td>马克华菲衬衫男2019秋季新款时尚白色字母刺绣牛津纺青年棉质上衣</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/94399436/O1CN...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1077</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=562348459515</td>\n",
       "      <td>238.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70538</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>36</td>\n",
       "      <td>596549376679</td>\n",
       "      <td>马克华菲夹克男士2019秋季新款潮流黑白格纹拼接休闲连帽外套</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/94399436/O1CN...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=596549376679</td>\n",
       "      <td>598.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70539</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>36</td>\n",
       "      <td>584971746856</td>\n",
       "      <td>IP合作猪系列马克华菲跨界针织衫男2019春季撞色毛巾绣红色毛衣</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/94399436/O1CN...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0</td>\n",
       "      <td>282</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=584971746856</td>\n",
       "      <td>298.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70540</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>36</td>\n",
       "      <td>596782917431</td>\n",
       "      <td>马克华菲针织衫男士2019秋季新款韩版潮流简约修身版长袖纯色毛衣</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/94399436/O1CN...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=596782917431</td>\n",
       "      <td>398.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70541</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>36</td>\n",
       "      <td>596782593849</td>\n",
       "      <td>马克华菲套头卫衣男2019秋季新款字母印花潮流长袖红色套头衫韩版</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/94399436/O1CN...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=596782593849</td>\n",
       "      <td>318.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70542</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>36</td>\n",
       "      <td>559359377589</td>\n",
       "      <td>马克华菲男装2017冬新款羽绒服男中长款上衣717415021053</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/94399436/TB1G...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0</td>\n",
       "      <td>118</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=559359377589</td>\n",
       "      <td>518.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70543</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>36</td>\n",
       "      <td>582866337693</td>\n",
       "      <td>马克华菲针织衫男士2019春装新款毛衫韩版保暖修身撞色提花毛衣潮</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/94399436/O1CN...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>139</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=582866337693</td>\n",
       "      <td>398.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70544</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>36</td>\n",
       "      <td>595890515007</td>\n",
       "      <td>马克华菲套头卫衣男2019秋季新款字母印花潮流长袖黑色套头衫韩版</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/94399436/O1CN...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=595890515007</td>\n",
       "      <td>318.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70545</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>36</td>\n",
       "      <td>562055154171</td>\n",
       "      <td>马克华菲男装2017冬新款羽绒服男长款上衣717415031051</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/94399436/TB1y...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=562055154171</td>\n",
       "      <td>478.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70546</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>36</td>\n",
       "      <td>561738986746</td>\n",
       "      <td>马克华菲羽绒服男士冬季新款短款个性贴布可拆卸织带潮流青少年</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/94399436/TB1N...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0</td>\n",
       "      <td>145</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=561738986746</td>\n",
       "      <td>358.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70547</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>36</td>\n",
       "      <td>566495371158</td>\n",
       "      <td>马克华菲男装夏季新款牛仔裤九分裤时尚潮流破洞裤</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/94399436/TB1....</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=566495371158</td>\n",
       "      <td>258.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70548</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>36</td>\n",
       "      <td>559482779078</td>\n",
       "      <td>马克华菲男装2017冬新款毛呢大衣男中长款717416021053</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/94399436/TB1P...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>86</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=559482779078</td>\n",
       "      <td>518.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70549</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>36</td>\n",
       "      <td>564019462996</td>\n",
       "      <td>马克华菲男装 春装ins刺绣时尚长裤纯色直筒黑色牛仔裤男潮牌</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/94399436/O1CN...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>650</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=564019462996</td>\n",
       "      <td>338.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70550</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>36</td>\n",
       "      <td>545152636765</td>\n",
       "      <td>Z马克华菲牛仔裤男修身潮流束脚春秋款字母小脚纯色休闲长裤子</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/94399436/TB2d...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>703</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=545152636765</td>\n",
       "      <td>228.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70551</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>36</td>\n",
       "      <td>569761554257</td>\n",
       "      <td>(世界杯系列）马克华菲男士短袖Polo衫夏季宽松字母刺绣T恤上衣潮</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/94399436/TB2x...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=569761554257</td>\n",
       "      <td>168.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70552</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>580120224489</td>\n",
       "      <td>马克华菲卫衣男冬装ins抽绳连帽字母印花清新长袖上衣</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/94399436/O1CN...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>161</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=580120224489</td>\n",
       "      <td>288.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70553</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>566211580504</td>\n",
       "      <td>马克华菲男装夏季新款牛仔裤九分裤时尚潮流修身裤</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/94399436/TB1t...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>45</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=566211580504</td>\n",
       "      <td>258.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70554</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>560204575399</td>\n",
       "      <td>商场同款马克华菲男装冬新款牛仔裤刺绣补丁裤子</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/94399436/TB16...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=560204575399</td>\n",
       "      <td>278.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70555</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>566211684272</td>\n",
       "      <td>马克华菲男装夏季潮流牛仔裤九分裤男时尚修身裤子</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/94399436/TB1d...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>96</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=566211684272</td>\n",
       "      <td>248.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70556</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>566328281571</td>\n",
       "      <td>不上商场同款马克华菲男装夏季新款牛仔九分裤时尚修</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/94399436/TB1I...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=566328281571</td>\n",
       "      <td>218.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70557</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>564265359516</td>\n",
       "      <td>马克华菲男装 春装ins破洞磨白帅气时尚小脚蓝色牛仔裤男潮牌</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/94399436/TB1i...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>72</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=564265359516</td>\n",
       "      <td>278.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70558</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>565047171287</td>\n",
       "      <td>马克华菲短裤男夏季潮流外穿休闲五分裤薄款韩版潮流宽松运动</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/94399436/TB2T...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>6936</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=565047171287</td>\n",
       "      <td>178.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70559</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>568373876819</td>\n",
       "      <td>马克华菲Polo衫男士夏季休闲字母印花拼接短袖上衣潮</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i4/94399436/TB1O...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>288</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=568373876819</td>\n",
       "      <td>168.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70560</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>565113759113</td>\n",
       "      <td>马克华菲男装夏季新款潮流外穿休闲短裤男清凉透气时尚沙滩裤</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i2/94399436/TB1H...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>357</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=565113759113</td>\n",
       "      <td>358.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70561</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>566211772075</td>\n",
       "      <td>马克华菲男装2018夏季新款短袖T恤男都市印花上衣</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/94399436/TB1s...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=566211772075</td>\n",
       "      <td>188.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70562</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>565030930448</td>\n",
       "      <td>【会员新风尚专享】马克华菲短袖polo男夏季短袖T恤时尚粉色上衣</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i1/94399436/TB1k...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>422</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=565030930448</td>\n",
       "      <td>258.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70563</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>570325834950</td>\n",
       "      <td>马克华菲2018夏季新款潮流休闲白色t恤男短袖夏</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/94399436/TB2O...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>58</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=570325834950</td>\n",
       "      <td>138.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70564</th>\n",
       "      <td>马克华菲</td>\n",
       "      <td>fairwhale</td>\n",
       "      <td>https://fairwhale.m.tmall.com</td>\n",
       "      <td>37</td>\n",
       "      <td>37</td>\n",
       "      <td>597257688462</td>\n",
       "      <td>马克华菲情侣牛仔裤男2019秋季新款复古宽松阔腿潮牌男直筒工装裤</td>\n",
       "      <td>//img.alicdn.com/bao/uploaded/i3/94399436/O1CN...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>//detail.m.tmall.com/item.htm?id=597257688462</td>\n",
       "      <td>338.0</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>70565 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         0          1                              2   3   4             5   \\\n",
       "0       a21      a21fs      https://a21fs.m.tmall.com  32   1  585000307760   \n",
       "1       a21      a21fs      https://a21fs.m.tmall.com  32   1  556905499087   \n",
       "2       a21      a21fs      https://a21fs.m.tmall.com  32   1  579126304648   \n",
       "3       a21      a21fs      https://a21fs.m.tmall.com  32   1  584857894258   \n",
       "4       a21      a21fs      https://a21fs.m.tmall.com  32   1  574998833929   \n",
       "5       a21      a21fs      https://a21fs.m.tmall.com  32   1  585884370566   \n",
       "6       a21      a21fs      https://a21fs.m.tmall.com  32   1  581181459462   \n",
       "7       a21      a21fs      https://a21fs.m.tmall.com  32   1  573079737250   \n",
       "8       a21      a21fs      https://a21fs.m.tmall.com  32   1  584519564405   \n",
       "9       a21      a21fs      https://a21fs.m.tmall.com  32   1  572188104468   \n",
       "10      a21      a21fs      https://a21fs.m.tmall.com  32   1  555337765523   \n",
       "11      a21      a21fs      https://a21fs.m.tmall.com  32   1  554745780852   \n",
       "12      a21      a21fs      https://a21fs.m.tmall.com  32   1  586339532894   \n",
       "13      a21      a21fs      https://a21fs.m.tmall.com  32   1  586840227706   \n",
       "14      a21      a21fs      https://a21fs.m.tmall.com  32   1  554820553199   \n",
       "15      a21      a21fs      https://a21fs.m.tmall.com  32   1  584858334178   \n",
       "16      a21      a21fs      https://a21fs.m.tmall.com  32   1  572319301147   \n",
       "17      a21      a21fs      https://a21fs.m.tmall.com  32   1  574480863419   \n",
       "18      a21      a21fs      https://a21fs.m.tmall.com  32   1  585000307753   \n",
       "19      a21      a21fs      https://a21fs.m.tmall.com  32   1  586317028452   \n",
       "20      a21      a21fs      https://a21fs.m.tmall.com  32   1  572711994246   \n",
       "21      a21      a21fs      https://a21fs.m.tmall.com  32   1  586840191726   \n",
       "22      a21      a21fs      https://a21fs.m.tmall.com  32   1  575214883533   \n",
       "23      a21      a21fs      https://a21fs.m.tmall.com  32   1  584726585869   \n",
       "24      a21      a21fs      https://a21fs.m.tmall.com  32   2  586556385876   \n",
       "25      a21      a21fs      https://a21fs.m.tmall.com  32   2  586339028488   \n",
       "26      a21      a21fs      https://a21fs.m.tmall.com  32   2  586888033034   \n",
       "27      a21      a21fs      https://a21fs.m.tmall.com  32   2  554908919545   \n",
       "28      a21      a21fs      https://a21fs.m.tmall.com  32   2  586840619069   \n",
       "29      a21      a21fs      https://a21fs.m.tmall.com  32   2  572809503192   \n",
       "...     ...        ...                            ...  ..  ..           ...   \n",
       "70535  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  36  574608134171   \n",
       "70536  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  36  564117145260   \n",
       "70537  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  36  562348459515   \n",
       "70538  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  36  596549376679   \n",
       "70539  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  36  584971746856   \n",
       "70540  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  36  596782917431   \n",
       "70541  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  36  596782593849   \n",
       "70542  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  36  559359377589   \n",
       "70543  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  36  582866337693   \n",
       "70544  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  36  595890515007   \n",
       "70545  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  36  562055154171   \n",
       "70546  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  36  561738986746   \n",
       "70547  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  36  566495371158   \n",
       "70548  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  36  559482779078   \n",
       "70549  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  36  564019462996   \n",
       "70550  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  36  545152636765   \n",
       "70551  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  36  569761554257   \n",
       "70552  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  37  580120224489   \n",
       "70553  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  37  566211580504   \n",
       "70554  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  37  560204575399   \n",
       "70555  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  37  566211684272   \n",
       "70556  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  37  566328281571   \n",
       "70557  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  37  564265359516   \n",
       "70558  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  37  565047171287   \n",
       "70559  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  37  568373876819   \n",
       "70560  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  37  565113759113   \n",
       "70561  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  37  566211772075   \n",
       "70562  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  37  565030930448   \n",
       "70563  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  37  570325834950   \n",
       "70564  马克华菲  fairwhale  https://fairwhale.m.tmall.com  37  37  597257688462   \n",
       "\n",
       "                                         6   \\\n",
       "0        A21夏季2019新款男装短袖T恤男纯色休闲基础百搭男士打底短袖上衣   \n",
       "1              A21男装男士外套冬季新款轻薄羽绒服男轻便薄款外套男短款   \n",
       "2          A21男装春夏季纯棉男裤牛仔裤男薄款小脚潮流 男生小直筒男款裤子   \n",
       "3        A21夏季2019新款男装短袖T恤男潮牌纯色圆领打底衫男上衣假两件套   \n",
       "4           A21男装秋季纯色毛衣男宽松圆领针织衫男长袖套头衫男生青年线衣   \n",
       "5       A21夏季2019新款男士短袖T恤潮流 简约百搭漫画体恤男ins潮港风   \n",
       "6           A21新款男装纯棉休闲裤男纯色 小直筒卡其色男裤子青年时尚百搭   \n",
       "7              A21春季男装新款连帽卫衣男潮假两件套头潮流嘻哈男生外套   \n",
       "8        A21男装夏季2019黑白短袖条纹t恤男圆领半袖t恤男条纹衣服男潮流   \n",
       "9          A21春夏季工装裤男潮牌束脚 欧美嘻哈薄款九分休闲裤子男运动纯棉   \n",
       "10            A21男修身牛仔裤潮流夏季弹力男士小脚裤休闲裤子男小脚长裤   \n",
       "11          A21男装春季新款长袖T恤男纯色男士圆领打底衫学生欧美修身上衣   \n",
       "12         A21夏季男装新款黑色工装裤 潮流个性男士休闲裤束脚九分裤子男潮   \n",
       "13     A21夏季2019动漫印花T恤男生短袖男ins潮百搭 男士打底衫休闲时尚   \n",
       "14            A21男士衬衣秋季白衬衫男长袖纯棉休闲牛津纺修身白色上衣潮   \n",
       "15        A21夏季新款字母印花体恤男白色圆领5分袖男t恤宽松t恤男嘻哈短袖   \n",
       "16           A21新款春季男生牛仔裤男修身小脚潮流弹力春秋款男士裤子潮牌   \n",
       "17             A21春季英伦连帽风衣男短款时尚外套男撞色潮牌冲锋衣帅气   \n",
       "18      A21新款2019夏季个性粉色T恤男短袖ins打底衫男圆领潮内搭男舒适   \n",
       "19         a21夏季新款男士动漫印花短袖t恤衫 纯棉衣服男潮牌个性休闲男装   \n",
       "20              A21九分裤男修身秋季低腰弹力水洗学生简约男士牛仔裤潮   \n",
       "21         A21夏季潮流新款束脚运动裤 印花弹力男装休闲裤黑色男士九分裤子   \n",
       "22               A21春装外套男装黄色连帽卫衣男长袖学生潮牌时尚上衣   \n",
       "23      A21夏季2019休闲插肩袖T恤男撞色圆领短袖男ins潮百搭上衣男印花   \n",
       "24          A21夏季纯棉工装裤男潮牌宽松直筒工装裤男束脚拉绳休闲裤男九分   \n",
       "25         A21夏季新款纯色休闲裤男士 修身男装九分裤子潮流百搭学生小脚裤   \n",
       "26          A21男装原宿直筒休闲裤男九分束脚运动裤男小脚收口夏季薄款潮流   \n",
       "27          A21夏季男士弹力休闲裤男修身潮流休闲百搭裤子男潮春夏小脚男裤   \n",
       "28         A21夏季潮流新款短裤男潮牌 学生军绿男士裤子街头男装运动休闲裤   \n",
       "29         A21九分裤男束脚 学生弹力潮流青年黑色简约舒适运动裤男士休闲裤   \n",
       "...                                     ...   \n",
       "70535            马克华菲大衣男2018秋冬宽松潮流绣花翻领羊毛呢外套   \n",
       "70536        马克华菲男装春装新款时尚ins复古破洞九分牛仔裤工装裤男潮牌   \n",
       "70537      马克华菲衬衫男2019秋季新款时尚白色字母刺绣牛津纺青年棉质上衣   \n",
       "70538        马克华菲夹克男士2019秋季新款潮流黑白格纹拼接休闲连帽外套   \n",
       "70539      IP合作猪系列马克华菲跨界针织衫男2019春季撞色毛巾绣红色毛衣   \n",
       "70540      马克华菲针织衫男士2019秋季新款韩版潮流简约修身版长袖纯色毛衣   \n",
       "70541      马克华菲套头卫衣男2019秋季新款字母印花潮流长袖红色套头衫韩版   \n",
       "70542    马克华菲男装2017冬新款羽绒服男中长款上衣717415021053   \n",
       "70543      马克华菲针织衫男士2019春装新款毛衫韩版保暖修身撞色提花毛衣潮   \n",
       "70544      马克华菲套头卫衣男2019秋季新款字母印花潮流长袖黑色套头衫韩版   \n",
       "70545     马克华菲男装2017冬新款羽绒服男长款上衣717415031051   \n",
       "70546         马克华菲羽绒服男士冬季新款短款个性贴布可拆卸织带潮流青少年   \n",
       "70547               马克华菲男装夏季新款牛仔裤九分裤时尚潮流破洞裤   \n",
       "70548     马克华菲男装2017冬新款毛呢大衣男中长款717416021053   \n",
       "70549        马克华菲男装 春装ins刺绣时尚长裤纯色直筒黑色牛仔裤男潮牌   \n",
       "70550         Z马克华菲牛仔裤男修身潮流束脚春秋款字母小脚纯色休闲长裤子   \n",
       "70551     (世界杯系列）马克华菲男士短袖Polo衫夏季宽松字母刺绣T恤上衣潮   \n",
       "70552            马克华菲卫衣男冬装ins抽绳连帽字母印花清新长袖上衣   \n",
       "70553               马克华菲男装夏季新款牛仔裤九分裤时尚潮流修身裤   \n",
       "70554                商场同款马克华菲男装冬新款牛仔裤刺绣补丁裤子   \n",
       "70555               马克华菲男装夏季潮流牛仔裤九分裤男时尚修身裤子   \n",
       "70556              不上商场同款马克华菲男装夏季新款牛仔九分裤时尚修   \n",
       "70557        马克华菲男装 春装ins破洞磨白帅气时尚小脚蓝色牛仔裤男潮牌   \n",
       "70558          马克华菲短裤男夏季潮流外穿休闲五分裤薄款韩版潮流宽松运动   \n",
       "70559            马克华菲Polo衫男士夏季休闲字母印花拼接短袖上衣潮   \n",
       "70560          马克华菲男装夏季新款潮流外穿休闲短裤男清凉透气时尚沙滩裤   \n",
       "70561             马克华菲男装2018夏季新款短袖T恤男都市印花上衣   \n",
       "70562      【会员新风尚专享】马克华菲短袖polo男夏季短袖T恤时尚粉色上衣   \n",
       "70563              马克华菲2018夏季新款潮流休闲白色t恤男短袖夏   \n",
       "70564      马克华菲情侣牛仔裤男2019秋季新款复古宽松阔腿潮牌男直筒工装裤   \n",
       "\n",
       "                                                      7        8   9       10  \\\n",
       "0      //img.alicdn.com/bao/uploaded/i4/1601145275/O1...  17180.0   0   83048   \n",
       "1      //img.alicdn.com/bao/uploaded/i3/1601145275/O1...     15.0   0   46689   \n",
       "2      //img.alicdn.com/bao/uploaded/i2/1601145275/O1...   7991.0   0   60043   \n",
       "3      //img.alicdn.com/bao/uploaded/i3/1601145275/O1...   8541.0   0   49793   \n",
       "4      //img.alicdn.com/bao/uploaded/i1/1601145275/O1...      0.0   0   11175   \n",
       "5      //img.alicdn.com/bao/uploaded/i2/1601145275/O1...   7005.0   0   24834   \n",
       "6      //img.alicdn.com/bao/uploaded/i1/1601145275/O1...   5918.0   0   50544   \n",
       "7      //img.alicdn.com/bao/uploaded/i4/1601145275/O1...     21.0   0   20936   \n",
       "8      //img.alicdn.com/bao/uploaded/i1/1601145275/O1...   4403.0   0   18716   \n",
       "9      //img.alicdn.com/bao/uploaded/i1/1601145275/O1...    192.0   0   29653   \n",
       "10     //img.alicdn.com/bao/uploaded/i4/1601145275/O1...   2336.0   0  110354   \n",
       "11     //img.alicdn.com/bao/uploaded/i4/1601145275/O1...    110.0   0   42113   \n",
       "12     //img.alicdn.com/bao/uploaded/i4/1601145275/O1...   3996.0   0   14274   \n",
       "13     //img.alicdn.com/bao/uploaded/i1/1601145275/O1...   5534.0   0   20959   \n",
       "14     //img.alicdn.com/bao/uploaded/i2/1601145275/O1...    381.0   0   53897   \n",
       "15     //img.alicdn.com/bao/uploaded/i1/1601145275/O1...   1609.0   0   11750   \n",
       "16     //img.alicdn.com/bao/uploaded/i2/1601145275/O1...    137.0   0   26742   \n",
       "17     //img.alicdn.com/bao/uploaded/i3/1601145275/O1...     73.0   0   11931   \n",
       "18     //img.alicdn.com/bao/uploaded/i4/1601145275/O1...   3332.0   0   16395   \n",
       "19     //img.alicdn.com/bao/uploaded/i2/1601145275/O1...   2297.0   0   12598   \n",
       "20     //img.alicdn.com/bao/uploaded/i3/1601145275/O1...    255.0   0   12760   \n",
       "21     //img.alicdn.com/bao/uploaded/i3/1601145275/O1...   3184.0   0   11385   \n",
       "22     //img.alicdn.com/bao/uploaded/i4/1601145275/O1...      8.0   0    6604   \n",
       "23     //img.alicdn.com/bao/uploaded/i4/1601145275/O1...   1447.0   0   10657   \n",
       "24     //img.alicdn.com/bao/uploaded/i4/1601145275/O1...   3278.0   0   12055   \n",
       "25     //img.alicdn.com/bao/uploaded/i1/1601145275/O1...   1110.0   0    6247   \n",
       "26     //img.alicdn.com/bao/uploaded/i1/1601145275/O1...    231.0   0    4232   \n",
       "27     //img.alicdn.com/bao/uploaded/i1/1601145275/O1...    693.0   0   73035   \n",
       "28     //img.alicdn.com/bao/uploaded/i4/1601145275/O1...   4278.0   0   13359   \n",
       "29     //img.alicdn.com/bao/uploaded/i1/1601145275/O1...    258.0   0    7613   \n",
       "...                                                  ...      ...  ..     ...   \n",
       "70535  //img.alicdn.com/bao/uploaded/i4/94399436/TB2r...      1.0   0     227   \n",
       "70536  //img.alicdn.com/bao/uploaded/i3/94399436/TB1Z...      2.0   0     332   \n",
       "70537  //img.alicdn.com/bao/uploaded/i1/94399436/O1CN...      2.0   0    1077   \n",
       "70538  //img.alicdn.com/bao/uploaded/i2/94399436/O1CN...      0.0   0       0   \n",
       "70539  //img.alicdn.com/bao/uploaded/i3/94399436/O1CN...      6.0   0     282   \n",
       "70540  //img.alicdn.com/bao/uploaded/i2/94399436/O1CN...      0.0   0       0   \n",
       "70541  //img.alicdn.com/bao/uploaded/i4/94399436/O1CN...      0.0   0       0   \n",
       "70542  //img.alicdn.com/bao/uploaded/i4/94399436/TB1G...      4.0   0     118   \n",
       "70543  //img.alicdn.com/bao/uploaded/i2/94399436/O1CN...      2.0   0     139   \n",
       "70544  //img.alicdn.com/bao/uploaded/i3/94399436/O1CN...      0.0   0       0   \n",
       "70545  //img.alicdn.com/bao/uploaded/i1/94399436/TB1y...      1.0   0       5   \n",
       "70546  //img.alicdn.com/bao/uploaded/i4/94399436/TB1N...     10.0   0     145   \n",
       "70547  //img.alicdn.com/bao/uploaded/i3/94399436/TB1....      1.0   0      36   \n",
       "70548  //img.alicdn.com/bao/uploaded/i2/94399436/TB1P...      3.0   0      86   \n",
       "70549  //img.alicdn.com/bao/uploaded/i4/94399436/O1CN...      2.0   0     650   \n",
       "70550  //img.alicdn.com/bao/uploaded/i3/94399436/TB2d...      2.0   0     703   \n",
       "70551  //img.alicdn.com/bao/uploaded/i1/94399436/TB2x...      1.0   0      16   \n",
       "70552  //img.alicdn.com/bao/uploaded/i1/94399436/O1CN...      2.0   0     161   \n",
       "70553  //img.alicdn.com/bao/uploaded/i3/94399436/TB1t...      2.0   0      45   \n",
       "70554  //img.alicdn.com/bao/uploaded/i2/94399436/TB16...      0.0   0       0   \n",
       "70555  //img.alicdn.com/bao/uploaded/i4/94399436/TB1d...      1.0   0      96   \n",
       "70556  //img.alicdn.com/bao/uploaded/i4/94399436/TB1I...      0.0   0       4   \n",
       "70557  //img.alicdn.com/bao/uploaded/i3/94399436/TB1i...      0.0   0      72   \n",
       "70558  //img.alicdn.com/bao/uploaded/i2/94399436/TB2T...      0.0   0    6936   \n",
       "70559  //img.alicdn.com/bao/uploaded/i4/94399436/TB1O...      2.0   0     288   \n",
       "70560  //img.alicdn.com/bao/uploaded/i2/94399436/TB1H...      0.0   0     357   \n",
       "70561  //img.alicdn.com/bao/uploaded/i3/94399436/TB1s...      0.0   0      32   \n",
       "70562  //img.alicdn.com/bao/uploaded/i1/94399436/TB1k...      0.0   0     422   \n",
       "70563  //img.alicdn.com/bao/uploaded/i3/94399436/TB2O...      0.0   0      58   \n",
       "70564  //img.alicdn.com/bao/uploaded/i3/94399436/O1CN...      0.0   0       0   \n",
       "\n",
       "                                                  11     12  13  \n",
       "0      //detail.m.tmall.com/item.htm?id=585000307760   59.0  []  \n",
       "1      //detail.m.tmall.com/item.htm?id=556905499087  219.0  []  \n",
       "2      //detail.m.tmall.com/item.htm?id=579126304648  119.0  []  \n",
       "3      //detail.m.tmall.com/item.htm?id=584857894258   69.0  []  \n",
       "4      //detail.m.tmall.com/item.htm?id=574998833929  169.0  []  \n",
       "5      //detail.m.tmall.com/item.htm?id=585884370566   69.0  []  \n",
       "6      //detail.m.tmall.com/item.htm?id=581181459462  119.0  []  \n",
       "7      //detail.m.tmall.com/item.htm?id=573079737250  149.0  []  \n",
       "8      //detail.m.tmall.com/item.htm?id=584519564405   79.0  []  \n",
       "9      //detail.m.tmall.com/item.htm?id=572188104468  159.0  []  \n",
       "10     //detail.m.tmall.com/item.htm?id=555337765523  139.0  []  \n",
       "11     //detail.m.tmall.com/item.htm?id=554745780852   69.0  []  \n",
       "12     //detail.m.tmall.com/item.htm?id=586339532894  159.0  []  \n",
       "13     //detail.m.tmall.com/item.htm?id=586840227706   69.0  []  \n",
       "14     //detail.m.tmall.com/item.htm?id=554820553199  139.0  []  \n",
       "15     //detail.m.tmall.com/item.htm?id=584858334178   79.0  []  \n",
       "16     //detail.m.tmall.com/item.htm?id=572319301147  169.0  []  \n",
       "17     //detail.m.tmall.com/item.htm?id=574480863419  219.0  []  \n",
       "18     //detail.m.tmall.com/item.htm?id=585000307753   79.0  []  \n",
       "19     //detail.m.tmall.com/item.htm?id=586317028452   69.0  []  \n",
       "20     //detail.m.tmall.com/item.htm?id=572711994246  159.0  []  \n",
       "21     //detail.m.tmall.com/item.htm?id=586840191726  159.0  []  \n",
       "22     //detail.m.tmall.com/item.htm?id=575214883533  149.0  []  \n",
       "23     //detail.m.tmall.com/item.htm?id=584726585869   69.0  []  \n",
       "24     //detail.m.tmall.com/item.htm?id=586556385876  169.0  []  \n",
       "25     //detail.m.tmall.com/item.htm?id=586339028488  149.0  []  \n",
       "26     //detail.m.tmall.com/item.htm?id=586888033034  149.0  []  \n",
       "27     //detail.m.tmall.com/item.htm?id=554908919545  149.0  []  \n",
       "28     //detail.m.tmall.com/item.htm?id=586840619069  109.0  []  \n",
       "29     //detail.m.tmall.com/item.htm?id=572809503192  149.0  []  \n",
       "...                                              ...    ...  ..  \n",
       "70535  //detail.m.tmall.com/item.htm?id=574608134171  898.0  []  \n",
       "70536  //detail.m.tmall.com/item.htm?id=564117145260  318.0  []  \n",
       "70537  //detail.m.tmall.com/item.htm?id=562348459515  238.0  []  \n",
       "70538  //detail.m.tmall.com/item.htm?id=596549376679  598.0  []  \n",
       "70539  //detail.m.tmall.com/item.htm?id=584971746856  298.0  []  \n",
       "70540  //detail.m.tmall.com/item.htm?id=596782917431  398.0  []  \n",
       "70541  //detail.m.tmall.com/item.htm?id=596782593849  318.0  []  \n",
       "70542  //detail.m.tmall.com/item.htm?id=559359377589  518.0  []  \n",
       "70543  //detail.m.tmall.com/item.htm?id=582866337693  398.0  []  \n",
       "70544  //detail.m.tmall.com/item.htm?id=595890515007  318.0  []  \n",
       "70545  //detail.m.tmall.com/item.htm?id=562055154171  478.0  []  \n",
       "70546  //detail.m.tmall.com/item.htm?id=561738986746  358.0  []  \n",
       "70547  //detail.m.tmall.com/item.htm?id=566495371158  258.0  []  \n",
       "70548  //detail.m.tmall.com/item.htm?id=559482779078  518.0  []  \n",
       "70549  //detail.m.tmall.com/item.htm?id=564019462996  338.0  []  \n",
       "70550  //detail.m.tmall.com/item.htm?id=545152636765  228.0  []  \n",
       "70551  //detail.m.tmall.com/item.htm?id=569761554257  168.0  []  \n",
       "70552  //detail.m.tmall.com/item.htm?id=580120224489  288.0  []  \n",
       "70553  //detail.m.tmall.com/item.htm?id=566211580504  258.0  []  \n",
       "70554  //detail.m.tmall.com/item.htm?id=560204575399  278.0  []  \n",
       "70555  //detail.m.tmall.com/item.htm?id=566211684272  248.0  []  \n",
       "70556  //detail.m.tmall.com/item.htm?id=566328281571  218.0  []  \n",
       "70557  //detail.m.tmall.com/item.htm?id=564265359516  278.0  []  \n",
       "70558  //detail.m.tmall.com/item.htm?id=565047171287  178.0  []  \n",
       "70559  //detail.m.tmall.com/item.htm?id=568373876819  168.0  []  \n",
       "70560  //detail.m.tmall.com/item.htm?id=565113759113  358.0  []  \n",
       "70561  //detail.m.tmall.com/item.htm?id=566211772075  188.0  []  \n",
       "70562  //detail.m.tmall.com/item.htm?id=565030930448  258.0  []  \n",
       "70563  //detail.m.tmall.com/item.htm?id=570325834950  138.0  []  \n",
       "70564  //detail.m.tmall.com/item.htm?id=597257688462  338.0  []  \n",
       "\n",
       "[70565 rows x 14 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "total_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "total_df.columns = ['品牌', '店铺', '店铺链接','总页数', '页数', '宝贝编号', '宝贝名称', '图片链接', '当月销量', '其他', '累计销量', '宝贝链接', '单价', 'pass']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "total_df['图片链接'] = 'https:' + total_df['图片链接']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "total_df['宝贝链接'] = 'https:' + total_df['宝贝链接']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "total_df['宝贝编号'] = total_df['宝贝编号'].astype('str')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "last_df = total_df[['品牌', '店铺', '页数', '宝贝编号', '宝贝名称', '单价', '当月销量', '累计销量', '图片链接', '宝贝链接']].copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "result_df = last_df.loc[last_df['宝贝名称'].str.contains('牛仔')].copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "excel_writer = pd.ExcelWriter(base_dir.parent.joinpath('牛仔32品牌0708.xlsx'), \n",
    "                              engine='xlsxwriter',\n",
    "                              options={'strings_to_urls': False})\n",
    "result_df.to_excel(excel_writer, index=False)\n",
    "excel_writer.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
